USE Master
go
IF  EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'AzureSearchSyncTest')
DROP DATABASE [AzureSearchSyncTest]
go

CREATE DATABASE AzureSearchSyncTest
go
USE AzureSearchSyncTest
go

CREATE TABLE [dbo].[Products](
	[ProductID] [int] NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[ProductNumber] [nvarchar](25) NOT NULL,
	[Color] [nvarchar](15) NULL,
	[StandardCost] [money] NOT NULL,
	[ListPrice] [money] NOT NULL,
	[Size] [nvarchar](5) NULL,
	[Weight] [decimal](8, 2) NULL,
	[SellStartDate] [datetime] NOT NULL,
	[SellEndDate] [datetime] NULL,
	[DiscontinuedDate] [datetime] NULL,
	[CategoryName] [nvarchar](50) NULL,
	[ModelName] [nvarchar](50) NULL,
	[Description] [nvarchar](400) NULL,
	[Version] [timestamp] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ProductID] ASC
)
)

GO

INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (680, N'HL Road Frame - Black, 58', N'FR-R92B-58', N'Black', 1059.3100, 1431.5000, N'58', CAST(1016.04 AS Decimal(8, 2)), CAST(0x00008C6900000000 AS DateTime), NULL, NULL, N'Road Frames', N'HL Road Frame', N'Our lightest and best quality aluminum frame made from the newest alloy; it is welded and heat-treated for strength. Our innovative design results in maximum comfort and performance.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (706, N'HL Road Frame - Red, 58', N'FR-R92R-58', N'Red', 1059.3100, 1431.5000, N'58', CAST(1016.04 AS Decimal(8, 2)), CAST(0x00008C6900000000 AS DateTime), NULL, NULL, N'Road Frames', N'HL Road Frame', N'Our lightest and best quality aluminum frame made from the newest alloy; it is welded and heat-treated for strength. Our innovative design results in maximum comfort and performance.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (707, N'Sport-100 Helmet, Red', N'HL-U509-R', N'Red', 13.0863, 34.9900, NULL, NULL, CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Helmets', N'Sport-100', N'Universal fit, well-vented, lightweight , snap-on visor.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (708, N'Sport-100 Helmet, Black', N'HL-U509', N'Black', 13.0863, 34.9900, NULL, NULL, CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Helmets', N'Sport-100', N'Universal fit, well-vented, lightweight , snap-on visor.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (709, N'Mountain Bike Socks, M', N'SO-B909-M', N'White', 3.3963, 9.5000, N'M', NULL, CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Socks', N'Mountain Bike Socks', N'Combination of natural and synthetic fibers stays dry and provides just the right cushioning.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (710, N'Mountain Bike Socks, L', N'SO-B909-L', N'White', 3.3963, 9.5000, N'L', NULL, CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Socks', N'Mountain Bike Socks', N'Combination of natural and synthetic fibers stays dry and provides just the right cushioning.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (711, N'Sport-100 Helmet, Blue', N'HL-U509-B', N'Blue', 13.0863, 34.9900, NULL, NULL, CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Helmets', N'Sport-100', N'Universal fit, well-vented, lightweight , snap-on visor.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (712, N'AWC Logo Cap', N'CA-1098', N'Multi', 6.9223, 8.9900, NULL, NULL, CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Caps', N'Cycling Cap', N'Traditional style with a flip-up brim; one-size fits all.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (713, N'Long-Sleeve Logo Jersey, S', N'LJ-0192-S', N'Multi', 38.4923, 49.9900, N'S', NULL, CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Jerseys', N'Long-Sleeve Logo Jersey', N'Unisex long-sleeve AWC logo microfiber cycling jersey')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (714, N'Long-Sleeve Logo Jersey, M', N'LJ-0192-M', N'Multi', 38.4923, 49.9900, N'M', NULL, CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Jerseys', N'Long-Sleeve Logo Jersey', N'Unisex long-sleeve AWC logo microfiber cycling jersey')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (715, N'Long-Sleeve Logo Jersey, L', N'LJ-0192-L', N'Multi', 38.4923, 49.9900, N'L', NULL, CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Jerseys', N'Long-Sleeve Logo Jersey', N'Unisex long-sleeve AWC logo microfiber cycling jersey')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (716, N'Long-Sleeve Logo Jersey, XL', N'LJ-0192-X', N'Multi', 38.4923, 49.9900, N'XL', NULL, CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Jerseys', N'Long-Sleeve Logo Jersey', N'Unisex long-sleeve AWC logo microfiber cycling jersey')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (717, N'HL Road Frame - Red, 62', N'FR-R92R-62', N'Red', 868.6342, 1431.5000, N'62', CAST(1043.26 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Road Frames', N'HL Road Frame', N'Our lightest and best quality aluminum frame made from the newest alloy; it is welded and heat-treated for strength. Our innovative design results in maximum comfort and performance.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (718, N'HL Road Frame - Red, 44', N'FR-R92R-44', N'Red', 868.6342, 1431.5000, N'44', CAST(961.61 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Road Frames', N'HL Road Frame', N'Our lightest and best quality aluminum frame made from the newest alloy; it is welded and heat-treated for strength. Our innovative design results in maximum comfort and performance.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (719, N'HL Road Frame - Red, 48', N'FR-R92R-48', N'Red', 868.6342, 1431.5000, N'48', CAST(979.75 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Road Frames', N'HL Road Frame', N'Our lightest and best quality aluminum frame made from the newest alloy; it is welded and heat-treated for strength. Our innovative design results in maximum comfort and performance.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (720, N'HL Road Frame - Red, 52', N'FR-R92R-52', N'Red', 868.6342, 1431.5000, N'52', CAST(997.90 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Road Frames', N'HL Road Frame', N'Our lightest and best quality aluminum frame made from the newest alloy; it is welded and heat-treated for strength. Our innovative design results in maximum comfort and performance.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (721, N'HL Road Frame - Red, 56', N'FR-R92R-56', N'Red', 868.6342, 1431.5000, N'56', CAST(1016.04 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Road Frames', N'HL Road Frame', N'Our lightest and best quality aluminum frame made from the newest alloy; it is welded and heat-treated for strength. Our innovative design results in maximum comfort and performance.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (722, N'LL Road Frame - Black, 58', N'FR-R38B-58', N'Black', 204.6251, 337.2200, N'58', CAST(1115.83 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Road Frames', N'LL Road Frame', N'The LL Frame provides a safe comfortable ride, while offering superior bump absorption in a value-priced aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (723, N'LL Road Frame - Black, 60', N'FR-R38B-60', N'Black', 204.6251, 337.2200, N'60', CAST(1124.90 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Road Frames', N'LL Road Frame', N'The LL Frame provides a safe comfortable ride, while offering superior bump absorption in a value-priced aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (724, N'LL Road Frame - Black, 62', N'FR-R38B-62', N'Black', 204.6251, 337.2200, N'62', CAST(1133.98 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Road Frames', N'LL Road Frame', N'The LL Frame provides a safe comfortable ride, while offering superior bump absorption in a value-priced aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (725, N'LL Road Frame - Red, 44', N'FR-R38R-44', N'Red', 187.1571, 337.2200, N'44', CAST(1052.33 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Frames', N'LL Road Frame', N'The LL Frame provides a safe comfortable ride, while offering superior bump absorption in a value-priced aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (726, N'LL Road Frame - Red, 48', N'FR-R38R-48', N'Red', 187.1571, 337.2200, N'48', CAST(1070.47 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Frames', N'LL Road Frame', N'The LL Frame provides a safe comfortable ride, while offering superior bump absorption in a value-priced aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (727, N'LL Road Frame - Red, 52', N'FR-R38R-52', N'Red', 187.1571, 337.2200, N'52', CAST(1088.62 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Frames', N'LL Road Frame', N'The LL Frame provides a safe comfortable ride, while offering superior bump absorption in a value-priced aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (728, N'LL Road Frame - Red, 58', N'FR-R38R-58', N'Red', 187.1571, 337.2200, N'58', CAST(1115.83 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Frames', N'LL Road Frame', N'The LL Frame provides a safe comfortable ride, while offering superior bump absorption in a value-priced aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (729, N'LL Road Frame - Red, 60', N'FR-R38R-60', N'Red', 187.1571, 337.2200, N'60', CAST(1124.90 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Frames', N'LL Road Frame', N'The LL Frame provides a safe comfortable ride, while offering superior bump absorption in a value-priced aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (730, N'LL Road Frame - Red, 62', N'FR-R38R-62', N'Red', 187.1571, 337.2200, N'62', CAST(1133.98 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Frames', N'LL Road Frame', N'The LL Frame provides a safe comfortable ride, while offering superior bump absorption in a value-priced aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (731, N'ML Road Frame - Red, 44', N'FR-R72R-44', N'Red', 352.1394, 594.8300, N'44', CAST(1006.97 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Road Frames', N'ML Road Frame', N'Made from the same aluminum alloy as our top-of-the line HL frame, the ML features a lightweight down-tube milled to the perfect diameter for optimal strength. Men''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (732, N'ML Road Frame - Red, 48', N'FR-R72R-48', N'Red', 352.1394, 594.8300, N'48', CAST(1025.11 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Road Frames', N'ML Road Frame', N'Made from the same aluminum alloy as our top-of-the line HL frame, the ML features a lightweight down-tube milled to the perfect diameter for optimal strength. Men''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (733, N'ML Road Frame - Red, 52', N'FR-R72R-52', N'Red', 352.1394, 594.8300, N'52', CAST(1043.26 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Road Frames', N'ML Road Frame', N'Made from the same aluminum alloy as our top-of-the line HL frame, the ML features a lightweight down-tube milled to the perfect diameter for optimal strength. Men''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (734, N'ML Road Frame - Red, 58', N'FR-R72R-58', N'Red', 352.1394, 594.8300, N'58', CAST(1070.47 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Road Frames', N'ML Road Frame', N'Made from the same aluminum alloy as our top-of-the line HL frame, the ML features a lightweight down-tube milled to the perfect diameter for optimal strength. Men''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (735, N'ML Road Frame - Red, 60', N'FR-R72R-60', N'Red', 352.1394, 594.8300, N'60', CAST(1079.54 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Road Frames', N'ML Road Frame', N'Made from the same aluminum alloy as our top-of-the line HL frame, the ML features a lightweight down-tube milled to the perfect diameter for optimal strength. Men''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (736, N'LL Road Frame - Black, 44', N'FR-R38B-44', N'Black', 204.6251, 337.2200, N'44', CAST(1052.33 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Road Frames', N'LL Road Frame', N'The LL Frame provides a safe comfortable ride, while offering superior bump absorption in a value-priced aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (737, N'LL Road Frame - Black, 48', N'FR-R38B-48', N'Black', 204.6251, 337.2200, N'48', CAST(1070.47 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Road Frames', N'LL Road Frame', N'The LL Frame provides a safe comfortable ride, while offering superior bump absorption in a value-priced aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (738, N'LL Road Frame - Black, 52', N'FR-R38B-52', N'Black', 204.6251, 337.2200, N'52', CAST(1088.62 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Road Frames', N'LL Road Frame', N'The LL Frame provides a safe comfortable ride, while offering superior bump absorption in a value-priced aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (739, N'HL Mountain Frame - Silver, 42', N'FR-M94S-42', N'Silver', 747.2002, 1364.5000, N'42', CAST(1233.76 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'HL Mountain Frame', N'Each frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (740, N'HL Mountain Frame - Silver, 44', N'FR-M94S-44', N'Silver', 706.8110, 1364.5000, N'44', CAST(1251.91 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Mountain Frames', N'HL Mountain Frame', N'Each frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (741, N'HL Mountain Frame - Silver, 48', N'FR-M94S-52', N'Silver', 706.8110, 1364.5000, N'48', CAST(1270.05 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Mountain Frames', N'HL Mountain Frame', N'Each frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (742, N'HL Mountain Frame - Silver, 46', N'FR-M94S-46', N'Silver', 747.2002, 1364.5000, N'46', CAST(1288.20 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'HL Mountain Frame', N'Each frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (743, N'HL Mountain Frame - Black, 42', N'FR-M94B-42', N'Black', 739.0410, 1349.6000, N'42', CAST(1233.76 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'HL Mountain Frame', N'Each frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (744, N'HL Mountain Frame - Black, 44', N'FR-M94B-44', N'Black', 699.0928, 1349.6000, N'44', CAST(1251.91 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Mountain Frames', N'HL Mountain Frame', N'Each frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (745, N'HL Mountain Frame - Black, 48', N'FR-M94B-48', N'Black', 699.0928, 1349.6000, N'48', CAST(1270.05 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Mountain Frames', N'HL Mountain Frame', N'Each frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (746, N'HL Mountain Frame - Black, 46', N'FR-M94B-46', N'Black', 739.0410, 1349.6000, N'46', CAST(1288.20 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'HL Mountain Frame', N'Each frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (747, N'HL Mountain Frame - Black, 38', N'FR-M94B-38', N'Black', 739.0410, 1349.6000, N'38', CAST(1215.62 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'HL Mountain Frame', N'Each frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (748, N'HL Mountain Frame - Silver, 38', N'FR-M94S-38', N'Silver', 747.2002, 1364.5000, N'38', CAST(1215.62 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'HL Mountain Frame', N'Each frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (749, N'Road-150 Red, 62', N'BK-R93R-62', N'Red', 2171.2942, 3578.2700, N'62', CAST(6803.85 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Road Bikes', N'Road-150', N'This bike is ridden by race winners. Developed with the Adventure Works Cycles professional race team, it has a extremely light heat-treated aluminum frame, and steering that allows precision control.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (750, N'Road-150 Red, 44', N'BK-R93R-44', N'Red', 2171.2942, 3578.2700, N'44', CAST(6245.93 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Road Bikes', N'Road-150', N'This bike is ridden by race winners. Developed with the Adventure Works Cycles professional race team, it has a extremely light heat-treated aluminum frame, and steering that allows precision control.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (751, N'Road-150 Red, 48', N'BK-R93R-48', N'Red', 2171.2942, 3578.2700, N'48', CAST(6409.23 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Road Bikes', N'Road-150', N'This bike is ridden by race winners. Developed with the Adventure Works Cycles professional race team, it has a extremely light heat-treated aluminum frame, and steering that allows precision control.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (752, N'Road-150 Red, 52', N'BK-R93R-52', N'Red', 2171.2942, 3578.2700, N'52', CAST(6540.77 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Road Bikes', N'Road-150', N'This bike is ridden by race winners. Developed with the Adventure Works Cycles professional race team, it has a extremely light heat-treated aluminum frame, and steering that allows precision control.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (753, N'Road-150 Red, 56', N'BK-R93R-56', N'Red', 2171.2942, 3578.2700, N'56', CAST(6658.70 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Road Bikes', N'Road-150', N'This bike is ridden by race winners. Developed with the Adventure Works Cycles professional race team, it has a extremely light heat-treated aluminum frame, and steering that allows precision control.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (754, N'Road-450 Red, 58', N'BK-R68R-58', N'Red', 884.7083, 1457.9900, N'58', CAST(8069.37 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Road Bikes', N'Road-450', N'A true multi-sport bike that offers streamlined riding and a revolutionary design. Aerodynamic design lets you ride with the pros, and the gearing will conquer hilly roads.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (755, N'Road-450 Red, 60', N'BK-R68R-60', N'Red', 884.7083, 1457.9900, N'60', CAST(8119.26 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Road Bikes', N'Road-450', N'A true multi-sport bike that offers streamlined riding and a revolutionary design. Aerodynamic design lets you ride with the pros, and the gearing will conquer hilly roads.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (756, N'Road-450 Red, 44', N'BK-R68R-44', N'Red', 884.7083, 1457.9900, N'44', CAST(7606.70 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Road Bikes', N'Road-450', N'A true multi-sport bike that offers streamlined riding and a revolutionary design. Aerodynamic design lets you ride with the pros, and the gearing will conquer hilly roads.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (757, N'Road-450 Red, 48', N'BK-R68R-48', N'Red', 884.7083, 1457.9900, N'48', CAST(7770.00 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Road Bikes', N'Road-450', N'A true multi-sport bike that offers streamlined riding and a revolutionary design. Aerodynamic design lets you ride with the pros, and the gearing will conquer hilly roads.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (758, N'Road-450 Red, 52', N'BK-R68R-52', N'Red', 884.7083, 1457.9900, N'52', CAST(7901.54 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Road Bikes', N'Road-450', N'A true multi-sport bike that offers streamlined riding and a revolutionary design. Aerodynamic design lets you ride with the pros, and the gearing will conquer hilly roads.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (759, N'Road-650 Red, 58', N'BK-R50R-58', N'Red', 486.7066, 782.9900, N'58', CAST(8976.55 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Bikes', N'Road-650', N'Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we''re famous for.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (760, N'Road-650 Red, 60', N'BK-R50R-60', N'Red', 486.7066, 782.9900, N'60', CAST(9026.44 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Bikes', N'Road-650', N'Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we''re famous for.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (761, N'Road-650 Red, 62', N'BK-R50R-62', N'Red', 486.7066, 782.9900, N'62', CAST(9071.80 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Bikes', N'Road-650', N'Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we''re famous for.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (762, N'Road-650 Red, 44', N'BK-R50R-44', N'Red', 486.7066, 782.9900, N'44', CAST(8513.88 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Bikes', N'Road-650', N'Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we''re famous for.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (763, N'Road-650 Red, 48', N'BK-R50R-48', N'Red', 486.7066, 782.9900, N'48', CAST(8677.18 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Bikes', N'Road-650', N'Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we''re famous for.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (764, N'Road-650 Red, 52', N'BK-R50R-52', N'Red', 486.7066, 782.9900, N'52', CAST(8808.72 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Bikes', N'Road-650', N'Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we''re famous for.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (765, N'Road-650 Black, 58', N'BK-R50B-58', N'Black', 486.7066, 782.9900, N'58', CAST(8976.55 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Bikes', N'Road-650', N'Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we''re famous for.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (766, N'Road-650 Black, 60', N'BK-R50B-60', N'Black', 486.7066, 782.9900, N'60', CAST(9026.44 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Bikes', N'Road-650', N'Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we''re famous for.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (767, N'Road-650 Black, 62', N'BK-R50B-62', N'Black', 486.7066, 782.9900, N'62', CAST(9071.80 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Bikes', N'Road-650', N'Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we''re famous for.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (768, N'Road-650 Black, 44', N'BK-R50B-44', N'Black', 486.7066, 782.9900, N'44', CAST(8513.88 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Bikes', N'Road-650', N'Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we''re famous for.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (769, N'Road-650 Black, 48', N'BK-R50B-48', N'Black', 486.7066, 782.9900, N'48', CAST(8677.18 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Bikes', N'Road-650', N'Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we''re famous for.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (770, N'Road-650 Black, 52', N'BK-R50B-52', N'Black', 486.7066, 782.9900, N'52', CAST(8808.72 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Bikes', N'Road-650', N'Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we''re famous for.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (771, N'Mountain-100 Silver, 38', N'BK-M82S-38', N'Silver', 1912.1544, 3399.9900, N'38', CAST(9230.56 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Mountain Bikes', N'Mountain-100', N'Top-of-the-line competition mountain bike. Performance-enhancing options include the innovative HL Frame, super-smooth front suspension, and traction for all terrain.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (772, N'Mountain-100 Silver, 42', N'BK-M82S-42', N'Silver', 1912.1544, 3399.9900, N'42', CAST(9421.06 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Mountain Bikes', N'Mountain-100', N'Top-of-the-line competition mountain bike. Performance-enhancing options include the innovative HL Frame, super-smooth front suspension, and traction for all terrain.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (773, N'Mountain-100 Silver, 44', N'BK-M82S-44', N'Silver', 1912.1544, 3399.9900, N'44', CAST(9584.36 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Mountain Bikes', N'Mountain-100', N'Top-of-the-line competition mountain bike. Performance-enhancing options include the innovative HL Frame, super-smooth front suspension, and traction for all terrain.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (774, N'Mountain-100 Silver, 48', N'BK-M82S-48', N'Silver', 1912.1544, 3399.9900, N'48', CAST(9715.90 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Mountain Bikes', N'Mountain-100', N'Top-of-the-line competition mountain bike. Performance-enhancing options include the innovative HL Frame, super-smooth front suspension, and traction for all terrain.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (775, N'Mountain-100 Black, 38', N'BK-M82B-38', N'Black', 1898.0944, 3374.9900, N'38', CAST(9230.56 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Mountain Bikes', N'Mountain-100', N'Top-of-the-line competition mountain bike. Performance-enhancing options include the innovative HL Frame, super-smooth front suspension, and traction for all terrain.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (776, N'Mountain-100 Black, 42', N'BK-M82B-42', N'Black', 1898.0944, 3374.9900, N'42', CAST(9421.06 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Mountain Bikes', N'Mountain-100', N'Top-of-the-line competition mountain bike. Performance-enhancing options include the innovative HL Frame, super-smooth front suspension, and traction for all terrain.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (777, N'Mountain-100 Black, 44', N'BK-M82B-44', N'Black', 1898.0944, 3374.9900, N'44', CAST(9584.36 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Mountain Bikes', N'Mountain-100', N'Top-of-the-line competition mountain bike. Performance-enhancing options include the innovative HL Frame, super-smooth front suspension, and traction for all terrain.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (778, N'Mountain-100 Black, 48', N'BK-M82B-48', N'Black', 1898.0944, 3374.9900, N'48', CAST(9715.90 AS Decimal(8, 2)), CAST(0x000090CF00000000 AS DateTime), CAST(0x0000923B00000000 AS DateTime), NULL, N'Mountain Bikes', N'Mountain-100', N'Top-of-the-line competition mountain bike. Performance-enhancing options include the innovative HL Frame, super-smooth front suspension, and traction for all terrain.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (779, N'Mountain-200 Silver, 38', N'BK-M68S-38', N'Silver', 1265.6195, 2319.9900, N'38', CAST(10591.33 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-200', N'Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (780, N'Mountain-200 Silver, 42', N'BK-M68S-42', N'Silver', 1265.6195, 2319.9900, N'42', CAST(10781.83 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-200', N'Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (781, N'Mountain-200 Silver, 46', N'BK-M68S-46', N'Silver', 1265.6195, 2319.9900, N'46', CAST(10945.13 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-200', N'Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (782, N'Mountain-200 Black, 38', N'BK-M68B-38', N'Black', 1251.9813, 2294.9900, N'38', CAST(10591.33 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-200', N'Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (783, N'Mountain-200 Black, 42', N'BK-M68B-42', N'Black', 1251.9813, 2294.9900, N'42', CAST(10781.83 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-200', N'Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (784, N'Mountain-200 Black, 46', N'BK-M68B-46', N'Black', 1251.9813, 2294.9900, N'46', CAST(10945.13 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-200', N'Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (785, N'Mountain-300 Black, 38', N'BK-M47B-38', N'Black', 598.4354, 1079.9900, N'38', CAST(11498.51 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Mountain Bikes', N'Mountain-300', N'For true trail addicts.  An extremely durable bike that will go anywhere and keep you in control on challenging terrain - without breaking your budget.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (786, N'Mountain-300 Black, 40', N'BK-M47B-40', N'Black', 598.4354, 1079.9900, N'40', CAST(11689.01 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Mountain Bikes', N'Mountain-300', N'For true trail addicts.  An extremely durable bike that will go anywhere and keep you in control on challenging terrain - without breaking your budget.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (787, N'Mountain-300 Black, 44', N'BK-M47B-44', N'Black', 598.4354, 1079.9900, N'44', CAST(11852.31 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Mountain Bikes', N'Mountain-300', N'For true trail addicts.  An extremely durable bike that will go anywhere and keep you in control on challenging terrain - without breaking your budget.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (788, N'Mountain-300 Black, 48', N'BK-M47B-48', N'Black', 598.4354, 1079.9900, N'48', CAST(11983.85 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Mountain Bikes', N'Mountain-300', N'For true trail addicts.  An extremely durable bike that will go anywhere and keep you in control on challenging terrain - without breaking your budget.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (789, N'Road-250 Red, 44', N'BK-R89R-44', N'Red', 1518.7864, 2443.3500, N'44', CAST(6699.52 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Bikes', N'Road-250', N'Alluminum-alloy frame provides a light, stiff ride, whether you are racing in the velodrome or on a demanding club ride on country roads.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (790, N'Road-250 Red, 48', N'BK-R89R-48', N'Red', 1518.7864, 2443.3500, N'48', CAST(6862.82 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Bikes', N'Road-250', N'Alluminum-alloy frame provides a light, stiff ride, whether you are racing in the velodrome or on a demanding club ride on country roads.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (791, N'Road-250 Red, 52', N'BK-R89R-52', N'Red', 1518.7864, 2443.3500, N'52', CAST(6994.36 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Road Bikes', N'Road-250', N'Alluminum-alloy frame provides a light, stiff ride, whether you are racing in the velodrome or on a demanding club ride on country roads.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (792, N'Road-250 Red, 58', N'BK-R89R-58', N'Red', 1554.9479, 2443.3500, N'58', CAST(7162.19 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Road Bikes', N'Road-250', N'Alluminum-alloy frame provides a light, stiff ride, whether you are racing in the velodrome or on a demanding club ride on country roads.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (793, N'Road-250 Black, 44', N'BK-R89B-44', N'Black', 1554.9479, 2443.3500, N'44', CAST(6699.52 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Road Bikes', N'Road-250', N'Alluminum-alloy frame provides a light, stiff ride, whether you are racing in the velodrome or on a demanding club ride on country roads.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (794, N'Road-250 Black, 48', N'BK-R89B-48', N'Black', 1554.9479, 2443.3500, N'48', CAST(6862.82 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Road Bikes', N'Road-250', N'Alluminum-alloy frame provides a light, stiff ride, whether you are racing in the velodrome or on a demanding club ride on country roads.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (795, N'Road-250 Black, 52', N'BK-R89B-52', N'Black', 1554.9479, 2443.3500, N'52', CAST(6994.36 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Road Bikes', N'Road-250', N'Alluminum-alloy frame provides a light, stiff ride, whether you are racing in the velodrome or on a demanding club ride on country roads.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (796, N'Road-250 Black, 58', N'BK-R89B-58', N'Black', 1554.9479, 2443.3500, N'58', CAST(7112.29 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Road Bikes', N'Road-250', N'Alluminum-alloy frame provides a light, stiff ride, whether you are racing in the velodrome or on a demanding club ride on country roads.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (797, N'Road-550-W Yellow, 38', N'BK-R64Y-38', N'Yellow', 713.0798, 1120.4900, N'38', CAST(7869.79 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Road Bikes', N'Road-550-W', N'Same technology as all of our Road series bikes, but the frame is sized for a woman.  Perfect all-around bike for road or racing.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (798, N'Road-550-W Yellow, 40', N'BK-R64Y-40', N'Yellow', 713.0798, 1120.4900, N'40', CAST(8060.29 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Road Bikes', N'Road-550-W', N'Same technology as all of our Road series bikes, but the frame is sized for a woman.  Perfect all-around bike for road or racing.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (799, N'Road-550-W Yellow, 42', N'BK-R64Y-42', N'Yellow', 713.0798, 1120.4900, N'42', CAST(8223.59 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Road Bikes', N'Road-550-W', N'Same technology as all of our Road series bikes, but the frame is sized for a woman.  Perfect all-around bike for road or racing.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (800, N'Road-550-W Yellow, 44', N'BK-R64Y-44', N'Yellow', 713.0798, 1120.4900, N'44', CAST(8355.13 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Road Bikes', N'Road-550-W', N'Same technology as all of our Road series bikes, but the frame is sized for a woman.  Perfect all-around bike for road or racing.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (801, N'Road-550-W Yellow, 48', N'BK-R64Y-48', N'Yellow', 713.0798, 1120.4900, N'48', CAST(8473.06 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Road Bikes', N'Road-550-W', N'Same technology as all of our Road series bikes, but the frame is sized for a woman.  Perfect all-around bike for road or racing.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (802, N'LL Fork', N'FK-1639', NULL, 65.8097, 148.2200, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Forks', N'LL Fork', N'Stout design absorbs shock and offers more precise steering.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (803, N'ML Fork', N'FK-5136', NULL, 77.9176, 175.4900, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Forks', N'ML Fork', N'Composite road fork with an aluminum steerer tube.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (804, N'HL Fork', N'FK-9939', NULL, 101.8936, 229.4900, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Forks', N'HL Fork', N'High-performance carbon road fork with curved legs.')
GO
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (805, N'LL Headset', N'HS-0296', NULL, 15.1848, 34.2000, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Headsets', N'LL Headset', N'Threadless headset provides quality at an economical price.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (806, N'ML Headset', N'HS-2451', NULL, 45.4168, 102.2900, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Headsets', N'ML Headset', N'Sealed cartridge keeps dirt out.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (807, N'HL Headset', N'HS-3479', NULL, 55.3801, 124.7300, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Headsets', N'HL Headset', N'High-quality 1" threadless headset with a grease port for quick lubrication.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (808, N'LL Mountain Handlebars', N'HB-M243', NULL, 19.7758, 44.5400, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Handlebars', N'LL Mountain Handlebars', N'All-purpose bar for on or off-road.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (809, N'ML Mountain Handlebars', N'HB-M763', NULL, 27.4925, 61.9200, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Handlebars', N'ML Mountain Handlebars', N'Tough aluminum alloy bars for downhill.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (810, N'HL Mountain Handlebars', N'HB-M918', NULL, 53.3999, 120.2700, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Handlebars', N'HL Mountain Handlebars', N'Flat bar strong enough for the pro circuit.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (811, N'LL Road Handlebars', N'HB-R504', NULL, 19.7758, 44.5400, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Handlebars', N'LL Road Handlebars', N'Unique shape provides easier reach to the levers.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (812, N'ML Road Handlebars', N'HB-R720', NULL, 27.4925, 61.9200, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Handlebars', N'ML Road Handlebars', N'Anatomically shaped aluminum tube bar will suit all riders.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (813, N'HL Road Handlebars', N'HB-R956', NULL, 53.3999, 120.2700, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Handlebars', N'HL Road Handlebars', N'Designed for racers; high-end anatomically shaped bar from aluminum alloy.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (814, N'ML Mountain Frame - Black, 38', N'FR-M63B-38', N'Black', 185.8193, 348.7600, N'38', CAST(1238.30 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Mountain Frames', N'ML Mountain Frame-W', N'The ML frame is a heat-treated aluminum frame made with the same detail and quality as our HL frame. It offers superior performance. Men''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (815, N'LL Mountain Front Wheel', N'FW-M423', N'Black', 26.9708, 60.7450, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Wheels', N'LL Mountain Front Wheel', N'Replacement mountain wheel for entry-level rider.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (816, N'ML Mountain Front Wheel', N'FW-M762', N'Black', 92.8071, 209.0250, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Wheels', N'ML Mountain Front Wheel', N'Replacement mountain wheel for the casual to serious rider.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (817, N'HL Mountain Front Wheel', N'FW-M928', N'Black', 133.2955, 300.2150, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Wheels', N'HL Mountain Front Wheel', N'High-performance mountain replacement wheel.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (818, N'LL Road Front Wheel', N'FW-R623', N'Black', 37.9909, 85.5650, NULL, CAST(900.00 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Wheels', N'LL Road Front Wheel', N'Replacement road front wheel for entry-level cyclist.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (819, N'ML Road Front Wheel', N'FW-R762', N'Black', 110.2829, 248.3850, NULL, CAST(850.00 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Wheels', N'ML Road Front Wheel', N'Sturdy alloy features a quick-release hub.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (820, N'HL Road Front Wheel', N'FW-R820', N'Black', 146.5466, 330.0600, NULL, CAST(650.00 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Wheels', N'HL Road Front Wheel', N'Strong wheel with double-walled rim.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (821, N'Touring Front Wheel', N'FW-T905', N'Black', 96.7964, 218.0100, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Wheels', N'Touring Front Wheel', N'Aerodynamic rims for smooth riding.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (822, N'ML Road Frame-W - Yellow, 38', N'FR-R72Y-38', N'Yellow', 360.9428, 594.8300, N'38', CAST(988.83 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Road Frames', N'ML Road Frame-W', N'Made from the same aluminum alloy as our top-of-the line HL frame, the ML features a lightweight down-tube milled to the perfect diameter for optimal strength. Women''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (823, N'LL Mountain Rear Wheel', N'RW-M423', N'Black', 38.9588, 87.7450, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Wheels', N'LL Mountain Rear Wheel', N'Replacement mountain wheel for entry-level rider.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (824, N'ML Mountain Rear Wheel', N'RW-M762', N'Black', 104.7951, 236.0250, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Wheels', N'ML Mountain Rear Wheel', N'Replacement mountain wheel for the casual to serious rider.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (825, N'HL Mountain Rear Wheel', N'RW-M928', N'Black', 145.2835, 327.2150, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Wheels', N'HL Mountain Rear Wheel', N'High-performance mountain replacement wheel.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (826, N'LL Road Rear Wheel', N'RW-R623', N'Black', 49.9789, 112.5650, NULL, CAST(1050.00 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Wheels', N'LL Road Rear Wheel', N'Replacement road rear wheel for entry-level cyclist.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (827, N'ML Road Rear Wheel', N'RW-R762', N'Black', 122.2709, 275.3850, NULL, CAST(1000.00 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Wheels', N'ML Road Rear Wheel', N'Aluminum alloy rim with stainless steel spokes; built for speed.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (828, N'HL Road Rear Wheel', N'RW-R820', N'Black', 158.5346, 357.0600, NULL, CAST(890.00 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Wheels', N'HL Road Rear Wheel', N'Strong rear wheel with double-walled rim.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (829, N'Touring Rear Wheel', N'RW-T905', N'Black', 108.7844, 245.0100, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Wheels', N'Touring Rear Wheel', N'Excellent aerodynamic rims guarantee a smooth ride.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (830, N'ML Mountain Frame - Black, 40', N'FR-M63B-40', N'Black', 185.8193, 348.7600, N'40', CAST(1256.44 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Mountain Frames', N'ML Mountain Frame', N'The ML frame is a heat-treated aluminum frame made with the same detail and quality as our HL frame. It offers superior performance. Women''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (831, N'ML Mountain Frame - Black, 44', N'FR-M63B-44', N'Black', 185.8193, 348.7600, N'44', CAST(1274.59 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Mountain Frames', N'ML Mountain Frame', N'The ML frame is a heat-treated aluminum frame made with the same detail and quality as our HL frame. It offers superior performance. Women''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (832, N'ML Mountain Frame - Black, 48', N'FR-M63B-48', N'Black', 185.8193, 348.7600, N'48', CAST(1292.73 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Mountain Frames', N'ML Mountain Frame', N'The ML frame is a heat-treated aluminum frame made with the same detail and quality as our HL frame. It offers superior performance. Women''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (833, N'ML Road Frame-W - Yellow, 40', N'FR-R72Y-40', N'Yellow', 360.9428, 594.8300, N'40', CAST(1006.97 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Road Frames', N'ML Road Frame-W', N'Made from the same aluminum alloy as our top-of-the line HL frame, the ML features a lightweight down-tube milled to the perfect diameter for optimal strength. Women''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (834, N'ML Road Frame-W - Yellow, 42', N'FR-R72Y-42', N'Yellow', 360.9428, 594.8300, N'42', CAST(1025.11 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Road Frames', N'ML Road Frame-W', N'Made from the same aluminum alloy as our top-of-the line HL frame, the ML features a lightweight down-tube milled to the perfect diameter for optimal strength. Women''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (835, N'ML Road Frame-W - Yellow, 44', N'FR-R72Y-44', N'Yellow', 360.9428, 594.8300, N'44', CAST(1043.26 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Road Frames', N'ML Road Frame-W', N'Made from the same aluminum alloy as our top-of-the line HL frame, the ML features a lightweight down-tube milled to the perfect diameter for optimal strength. Women''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (836, N'ML Road Frame-W - Yellow, 48', N'FR-R72Y-48', N'Yellow', 360.9428, 594.8300, N'48', CAST(1061.40 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Road Frames', N'ML Road Frame-W', N'Made from the same aluminum alloy as our top-of-the line HL frame, the ML features a lightweight down-tube milled to the perfect diameter for optimal strength. Women''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (837, N'HL Road Frame - Black, 62', N'FR-R92B-62', N'Black', 868.6342, 1431.5000, N'62', CAST(1043.26 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Road Frames', N'HL Road Frame', N'Our lightest and best quality aluminum frame made from the newest alloy; it is welded and heat-treated for strength. Our innovative design results in maximum comfort and performance.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (838, N'HL Road Frame - Black, 44', N'FR-R92B-44', N'Black', 868.6342, 1431.5000, N'44', CAST(961.61 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Road Frames', N'HL Road Frame', N'Our lightest and best quality aluminum frame made from the newest alloy; it is welded and heat-treated for strength. Our innovative design results in maximum comfort and performance.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (839, N'HL Road Frame - Black, 48', N'FR-R92B-48', N'Black', 868.6342, 1431.5000, N'48', CAST(979.75 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Road Frames', N'HL Road Frame', N'Our lightest and best quality aluminum frame made from the newest alloy; it is welded and heat-treated for strength. Our innovative design results in maximum comfort and performance.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (840, N'HL Road Frame - Black, 52', N'FR-R92B-52', N'Black', 868.6342, 1431.5000, N'52', CAST(997.90 AS Decimal(8, 2)), CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Road Frames', N'HL Road Frame', N'Our lightest and best quality aluminum frame made from the newest alloy; it is welded and heat-treated for strength. Our innovative design results in maximum comfort and performance.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (841, N'Men''s Sports Shorts, S', N'SH-M897-S', N'Black', 24.7459, 59.9900, N'S', NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Shorts', N'Men''s Sports Shorts', N'Men''s 8-panel racing shorts - lycra with an elastic waistband and leg grippers.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (842, N'Touring-Panniers, Large', N'PA-T100', N'Grey', 51.5625, 125.0000, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Panniers', N'Touring-Panniers', N'Durable, water-proof nylon construction with easy access. Large enough for weekend trips.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (843, N'Cable Lock', N'LO-C100', NULL, 10.3125, 25.0000, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Locks', N'Cable Lock', N'Wraps to fit front and rear tires, carrier and 2 keys included.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (844, N'Minipump', N'PU-0452', NULL, 8.2459, 19.9900, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Pumps', N'Minipump', N'Designed for convenience. Fits in your pocket. Aluminum barrel. 160psi rated.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (845, N'Mountain Pump', N'PU-M044', NULL, 10.3084, 24.9900, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Pumps', N'Mountain Pump', N'Simple and light-weight. Emergency patches stored in handle.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (846, N'Taillights - Battery-Powered', N'LT-T990', NULL, 5.7709, 13.9900, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Lights', N'Taillight', N'Affordable light for safe night riding - uses 3 AAA batteries')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (847, N'Headlights - Dual-Beam', N'LT-H902', NULL, 14.4334, 34.9900, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Lights', N'Headlights - Dual-Beam', N'Rechargeable dual-beam headlight.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (848, N'Headlights - Weatherproof', N'LT-H903', NULL, 18.5584, 44.9900, NULL, NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Lights', N'Headlights - Weatherproof', N'Rugged weatherproof headlight.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (849, N'Men''s Sports Shorts, M', N'SH-M897-M', N'Black', 24.7459, 59.9900, N'M', NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Shorts', N'Men''s Sports Shorts', N'Men''s 8-panel racing shorts - lycra with an elastic waistband and leg grippers.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (850, N'Men''s Sports Shorts, L', N'SH-M897-L', N'Black', 24.7459, 59.9900, N'L', NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Shorts', N'Men''s Sports Shorts', N'Men''s 8-panel racing shorts - lycra with an elastic waistband and leg grippers.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (851, N'Men''s Sports Shorts, XL', N'SH-M897-X', N'Black', 24.7459, 59.9900, N'XL', NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Shorts', N'Men''s Sports Shorts', N'Men''s 8-panel racing shorts - lycra with an elastic waistband and leg grippers.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (852, N'Women''s Tights, S', N'TG-W091-S', N'Black', 30.9334, 74.9900, N'S', NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Tights', N'Women''s Tights', N'Warm spandex tights for winter riding; seamless chamois construction eliminates pressure points.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (853, N'Women''s Tights, M', N'TG-W091-M', N'Black', 30.9334, 74.9900, N'M', NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Tights', N'Women''s Tights', N'Warm spandex tights for winter riding; seamless chamois construction eliminates pressure points.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (854, N'Women''s Tights, L', N'TG-W091-L', N'Black', 30.9334, 74.9900, N'L', NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Tights', N'Women''s Tights', N'Warm spandex tights for winter riding; seamless chamois construction eliminates pressure points.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (855, N'Men''s Bib-Shorts, S', N'SB-M891-S', N'Multi', 37.1209, 89.9900, N'S', NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Bib-Shorts', N'Men''s Bib-Shorts', N'Designed for the AWC team with stay-put straps, moisture-control, chamois padding, and leg grippers.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (856, N'Men''s Bib-Shorts, M', N'SB-M891-M', N'Multi', 37.1209, 89.9900, N'M', NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Bib-Shorts', N'Men''s Bib-Shorts', N'Designed for the AWC team with stay-put straps, moisture-control, chamois padding, and leg grippers.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (857, N'Men''s Bib-Shorts, L', N'SB-M891-L', N'Multi', 37.1209, 89.9900, N'L', NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Bib-Shorts', N'Men''s Bib-Shorts', N'Designed for the AWC team with stay-put straps, moisture-control, chamois padding, and leg grippers.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (858, N'Half-Finger Gloves, S', N'GL-H102-S', N'Black', 9.1593, 24.4900, N'S', NULL, CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Gloves', N'Half-Finger Gloves', N'Full padding, improved finger flex, durable palm, adjustable closure.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (859, N'Half-Finger Gloves, M', N'GL-H102-M', N'Black', 9.1593, 24.4900, N'M', NULL, CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Gloves', N'Half-Finger Gloves', N'Full padding, improved finger flex, durable palm, adjustable closure.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (860, N'Half-Finger Gloves, L', N'GL-H102-L', N'Black', 9.1593, 24.4900, N'L', NULL, CAST(0x0000923C00000000 AS DateTime), NULL, NULL, N'Gloves', N'Half-Finger Gloves', N'Full padding, improved finger flex, durable palm, adjustable closure.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (861, N'Full-Finger Gloves, S', N'GL-F110-S', N'Black', 15.6709, 37.9900, N'S', NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Gloves', N'Full-Finger Gloves', N'Synthetic palm, flexible knuckles, breathable mesh upper. Worn by the AWC team riders.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (862, N'Full-Finger Gloves, M', N'GL-F110-M', N'Black', 15.6709, 37.9900, N'M', NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Gloves', N'Full-Finger Gloves', N'Synthetic palm, flexible knuckles, breathable mesh upper. Worn by the AWC team riders.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (863, N'Full-Finger Gloves, L', N'GL-F110-L', N'Black', 15.6709, 37.9900, N'L', NULL, CAST(0x0000923C00000000 AS DateTime), CAST(0x000093A800000000 AS DateTime), NULL, N'Gloves', N'Full-Finger Gloves', N'Synthetic palm, flexible knuckles, breathable mesh upper. Worn by the AWC team riders.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (864, N'Classic Vest, S', N'VE-C304-S', N'Blue', 23.7490, 63.5000, N'S', NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Vests', N'Classic Vest', N'Light-weight, wind-resistant, packs to fit into a pocket.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (865, N'Classic Vest, M', N'VE-C304-M', N'Blue', 23.7490, 63.5000, N'M', NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Vests', N'Classic Vest', N'Light-weight, wind-resistant, packs to fit into a pocket.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (866, N'Classic Vest, L', N'VE-C304-L', N'Blue', 23.7490, 63.5000, N'L', NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Vests', N'Classic Vest', N'Light-weight, wind-resistant, packs to fit into a pocket.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (867, N'Women''s Mountain Shorts, S', N'SH-W890-S', N'Black', 26.1763, 69.9900, N'S', NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Shorts', N'Women''s Mountain Shorts', N'Heavy duty, abrasion-resistant shorts feature seamless, lycra inner shorts with anti-bacterial chamois for comfort.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (868, N'Women''s Mountain Shorts, M', N'SH-W890-M', N'Black', 26.1763, 69.9900, N'M', NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Shorts', N'Women''s Mountain Shorts', N'Heavy duty, abrasion-resistant shorts feature seamless, lycra inner shorts with anti-bacterial chamois for comfort.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (869, N'Women''s Mountain Shorts, L', N'SH-W890-L', N'Black', 26.1763, 69.9900, N'L', NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Shorts', N'Women''s Mountain Shorts', N'Heavy duty, abrasion-resistant shorts feature seamless, lycra inner shorts with anti-bacterial chamois for comfort.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (870, N'Water Bottle - 30 oz.', N'WB-H098', NULL, 1.8663, 4.9900, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Bottles and Cages', N'Water Bottle', N'AWC logo water bottle - holds 30 oz; leak-proof.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (871, N'Mountain Bottle Cage', N'BC-M005', NULL, 3.7363, 9.9900, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Bottles and Cages', N'Mountain Bottle Cage', N'Tough aluminum cage holds bottle securly on tough terrain.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (872, N'Road Bottle Cage', N'BC-R205', NULL, 3.3623, 8.9900, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Bottles and Cages', N'Road Bottle Cage', N'Aluminum cage is lighter than our mountain version; perfect for long distance trips.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (873, N'Patch Kit/8 Patches', N'PK-7098', NULL, 0.8565, 2.2900, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Tires and Tubes', N'Patch kit', N'Includes 8 different size patches, glue and sandpaper.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (874, N'Racing Socks, M', N'SO-R809-M', N'White', 3.3623, 8.9900, N'M', NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Socks', N'Racing Socks', N'Thin, lightweight and durable with cuffs that stay up.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (875, N'Racing Socks, L', N'SO-R809-L', N'White', 3.3623, 8.9900, N'L', NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Socks', N'Racing Socks', N'Thin, lightweight and durable with cuffs that stay up.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (876, N'Hitch Rack - 4-Bike', N'RA-H123', NULL, 44.8800, 120.0000, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Bike Racks', N'Hitch Rack - 4-Bike', N'Carries 4 bikes securely; steel construction, fits 2" receiver hitch.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (877, N'Bike Wash - Dissolver', N'CL-9009', NULL, 2.9733, 7.9500, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Cleaners', N'Bike Wash', N'Washes off the toughest road grime; dissolves grease, environmentally safe. 1-liter bottle.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (878, N'Fender Set - Mountain', N'FE-6654', NULL, 8.2205, 21.9800, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Fenders', N'Fender Set - Mountain', N'Clip-on fenders fit most mountain bikes.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (879, N'All-Purpose Bike Stand', N'ST-1401', NULL, 59.4660, 159.0000, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Bike Stands', N'All-Purpose Bike Stand', N'Perfect all-purpose bike stand for working on your bike at home. Quick-adjusting clamps and steel construction.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (880, N'Hydration Pack - 70 oz.', N'HY-1023-70', N'Silver', 20.5663, 54.9900, N'70', NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Hydration Packs', N'Hydration Pack', N'Versatile 70 oz hydration pack offers extra storage, easy-fill access, and a waist belt.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (881, N'Short-Sleeve Classic Jersey, S', N'SJ-0194-S', N'Yellow', 41.5723, 53.9900, N'S', NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Jerseys', N'Short-Sleeve Classic Jersey', N'Short sleeve classic breathable jersey with superior moisture control, front zipper, and 3 back pockets.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (882, N'Short-Sleeve Classic Jersey, M', N'SJ-0194-M', N'Yellow', 41.5723, 53.9900, N'M', NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Jerseys', N'Short-Sleeve Classic Jersey', N'Short sleeve classic breathable jersey with superior moisture control, front zipper, and 3 back pockets.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (883, N'Short-Sleeve Classic Jersey, L', N'SJ-0194-L', N'Yellow', 41.5723, 53.9900, N'L', NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Jerseys', N'Short-Sleeve Classic Jersey', N'Short sleeve classic breathable jersey with superior moisture control, front zipper, and 3 back pockets.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (884, N'Short-Sleeve Classic Jersey, XL', N'SJ-0194-X', N'Yellow', 41.5723, 53.9900, N'XL', NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Jerseys', N'Short-Sleeve Classic Jersey', N'Short sleeve classic breathable jersey with superior moisture control, front zipper, and 3 back pockets.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (885, N'HL Touring Frame - Yellow, 60', N'FR-T98Y-60', N'Yellow', 601.7437, 1003.9100, N'60', CAST(1397.06 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Frames', N'HL Touring Frame', N'The HL aluminum frame is custom-shaped for both good looks and strength; it will withstand the most rigorous challenges of daily riding. Men''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (886, N'LL Touring Frame - Yellow, 62', N'FR-T67Y-62', N'Yellow', 199.8519, 333.4200, N'62', CAST(1451.49 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Frames', N'LL Touring Frame', N'Lightweight butted aluminum frame provides a more upright riding position for a trip around town.  Our ground-breaking design provides optimum comfort.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (887, N'HL Touring Frame - Yellow, 46', N'FR-T98Y-46', N'Yellow', 601.7437, 1003.9100, N'46', CAST(1342.63 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Frames', N'HL Touring Frame', N'The HL aluminum frame is custom-shaped for both good looks and strength; it will withstand the most rigorous challenges of daily riding. Men''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (888, N'HL Touring Frame - Yellow, 50', N'FR-T98Y-50', N'Yellow', 601.7437, 1003.9100, N'50', CAST(1360.77 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Frames', N'HL Touring Frame', N'The HL aluminum frame is custom-shaped for both good looks and strength; it will withstand the most rigorous challenges of daily riding. Men''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (889, N'HL Touring Frame - Yellow, 54', N'FR-T98Y-54', N'Yellow', 601.7437, 1003.9100, N'54', CAST(1378.91 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Frames', N'HL Touring Frame', N'The HL aluminum frame is custom-shaped for both good looks and strength; it will withstand the most rigorous challenges of daily riding. Men''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (890, N'HL Touring Frame - Blue, 46', N'FR-T98U-46', N'Blue', 601.7437, 1003.9100, N'46', CAST(1342.63 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Frames', N'HL Touring Frame', N'The HL aluminum frame is custom-shaped for both good looks and strength; it will withstand the most rigorous challenges of daily riding. Men''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (891, N'HL Touring Frame - Blue, 50', N'FR-T98U-50', N'Blue', 601.7437, 1003.9100, N'50', CAST(1360.77 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Frames', N'HL Touring Frame', N'The HL aluminum frame is custom-shaped for both good looks and strength; it will withstand the most rigorous challenges of daily riding. Men''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (892, N'HL Touring Frame - Blue, 54', N'FR-T98U-54', N'Blue', 601.7437, 1003.9100, N'54', CAST(1378.91 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Frames', N'HL Touring Frame', N'The HL aluminum frame is custom-shaped for both good looks and strength; it will withstand the most rigorous challenges of daily riding. Men''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (893, N'HL Touring Frame - Blue, 60', N'FR-T98U-60', N'Blue', 601.7437, 1003.9100, N'60', CAST(1397.06 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Frames', N'HL Touring Frame', N'The HL aluminum frame is custom-shaped for both good looks and strength; it will withstand the most rigorous challenges of daily riding. Men''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (894, N'Rear Derailleur', N'RD-2308', N'Silver', 53.9282, 121.4600, NULL, CAST(215.00 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Derailleurs', N'Rear Derailleur', N'Wide-link design.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (895, N'LL Touring Frame - Blue, 50', N'FR-T67U-50', N'Blue', 199.8519, 333.4200, N'50', CAST(1406.13 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Frames', N'LL Touring Frame', N'Lightweight butted aluminum frame provides a more upright riding position for a trip around town.  Our ground-breaking design provides optimum comfort.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (896, N'LL Touring Frame - Blue, 54', N'FR-T67U-54', N'Blue', 199.8519, 333.4200, N'54', CAST(1424.27 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Frames', N'LL Touring Frame', N'Lightweight butted aluminum frame provides a more upright riding position for a trip around town.  Our ground-breaking design provides optimum comfort.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (897, N'LL Touring Frame - Blue, 58', N'FR-T67U-58', N'Blue', 199.8519, 333.4200, N'58', CAST(1433.34 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Frames', N'LL Touring Frame', N'Lightweight butted aluminum frame provides a more upright riding position for a trip around town.  Our ground-breaking design provides optimum comfort.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (898, N'LL Touring Frame - Blue, 62', N'FR-T67U-62', N'Blue', 199.8519, 333.4200, N'62', CAST(1451.49 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Frames', N'LL Touring Frame', N'Lightweight butted aluminum frame provides a more upright riding position for a trip around town.  Our ground-breaking design provides optimum comfort.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (899, N'LL Touring Frame - Yellow, 44', N'FR-T67Y-44', N'Yellow', 199.8519, 333.4200, N'44', CAST(1369.84 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Frames', N'LL Touring Frame', N'Lightweight butted aluminum frame provides a more upright riding position for a trip around town.  Our ground-breaking design provides optimum comfort.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (900, N'LL Touring Frame - Yellow, 50', N'FR-T67Y-50', N'Yellow', 199.8519, 333.4200, N'50', CAST(1406.13 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Frames', N'LL Touring Frame', N'Lightweight butted aluminum frame provides a more upright riding position for a trip around town.  Our ground-breaking design provides optimum comfort.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (901, N'LL Touring Frame - Yellow, 54', N'FR-T67Y-54', N'Yellow', 199.8519, 333.4200, N'54', CAST(1424.27 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Frames', N'LL Touring Frame', N'Lightweight butted aluminum frame provides a more upright riding position for a trip around town.  Our ground-breaking design provides optimum comfort.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (902, N'LL Touring Frame - Yellow, 58', N'FR-T67Y-58', N'Yellow', 199.8519, 333.4200, N'58', CAST(1433.34 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Frames', N'LL Touring Frame', N'Lightweight butted aluminum frame provides a more upright riding position for a trip around town.  Our ground-breaking design provides optimum comfort.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (903, N'LL Touring Frame - Blue, 44', N'FR-T67U-44', N'Blue', 199.8519, 333.4200, N'44', CAST(1369.84 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Frames', N'LL Touring Frame', N'Lightweight butted aluminum frame provides a more upright riding position for a trip around town.  Our ground-breaking design provides optimum comfort.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (904, N'ML Mountain Frame-W - Silver, 40', N'FR-M63S-40', N'Silver', 199.3757, 364.0900, N'40', CAST(1256.44 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'ML Mountain Frame-W', N'The ML frame is a heat-treated aluminum frame made with the same detail and quality as our HL frame. It offers superior performance. Men''s version.')
GO
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (905, N'ML Mountain Frame-W - Silver, 42', N'FR-M63S-42', N'Silver', 199.3757, 364.0900, N'42', CAST(1274.59 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'ML Mountain Frame-W', N'The ML frame is a heat-treated aluminum frame made with the same detail and quality as our HL frame. It offers superior performance. Men''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (906, N'ML Mountain Frame-W - Silver, 46', N'FR-M63S-46', N'Silver', 199.3757, 364.0900, N'46', CAST(1292.73 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'ML Mountain Frame-W', N'The ML frame is a heat-treated aluminum frame made with the same detail and quality as our HL frame. It offers superior performance. Men''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (908, N'LL Mountain Seat/Saddle', N'SE-M236', NULL, 12.0413, 27.1200, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Saddles', N'LL Mountain Seat/Saddle 2', N'Synthetic leather. Features gel for increased comfort.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (909, N'ML Mountain Seat/Saddle', N'SE-M798', NULL, 17.3782, 39.1400, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Saddles', N'ML Mountain Seat/Saddle 2', N'Designed to absorb shock.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (910, N'HL Mountain Seat/Saddle', N'SE-M940', NULL, 23.3722, 52.6400, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Saddles', N'HL Mountain Seat/Saddle 2', N'Anatomic design for a full-day of riding in comfort. Durable leather.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (911, N'LL Road Seat/Saddle', N'SE-R581', NULL, 12.0413, 27.1200, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Saddles', N'LL Road Seat/Saddle 1', N'Lightweight foam-padded saddle.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (912, N'ML Road Seat/Saddle', N'SE-R908', NULL, 17.3782, 39.1400, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Saddles', N'ML Road Seat/Saddle 2', N'Rubber bumpers absorb bumps.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (913, N'HL Road Seat/Saddle', N'SE-R995', NULL, 23.3722, 52.6400, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Saddles', N'HL Road Seat/Saddle 2', N'Lightweight kevlar racing saddle. Leather.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (914, N'LL Touring Seat/Saddle', N'SE-T312', NULL, 12.0413, 27.1200, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Saddles', N'LL Touring Seat/Saddle', N'Comfortable, ergonomically shaped gel saddle.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (915, N'ML Touring Seat/Saddle', N'SE-T762', NULL, 17.3782, 39.1400, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Saddles', N'ML Touring Seat/Saddle', N'New design relieves pressure for long rides.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (916, N'HL Touring Seat/Saddle', N'SE-T924', NULL, 23.3722, 52.6400, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Saddles', N'HL Touring Seat/Saddle', N'Cut-out shell for a more comfortable ride.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (917, N'LL Mountain Frame - Silver, 42', N'FR-M21S-42', N'Silver', 144.5938, 264.0500, N'42', CAST(1324.48 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'LL Mountain Frame', N'Our best value utilizing the same, ground-breaking frame technology as the ML aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (918, N'LL Mountain Frame - Silver, 44', N'FR-M21S-44', N'Silver', 144.5938, 264.0500, N'44', CAST(1342.63 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'LL Mountain Frame', N'Our best value utilizing the same, ground-breaking frame technology as the ML aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (919, N'LL Mountain Frame - Silver, 48', N'FR-M21S-48', N'Silver', 144.5938, 264.0500, N'48', CAST(1360.77 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'LL Mountain Frame', N'Our best value utilizing the same, ground-breaking frame technology as the ML aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (920, N'LL Mountain Frame - Silver, 52', N'FR-M21S-52', N'Silver', 144.5938, 264.0500, N'52', CAST(1378.91 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'LL Mountain Frame', N'Our best value utilizing the same, ground-breaking frame technology as the ML aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (921, N'Mountain Tire Tube', N'TT-M928', NULL, 1.8663, 4.9900, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Tires and Tubes', N'Mountain Tire Tube', N'Self-sealing tube.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (922, N'Road Tire Tube', N'TT-R982', NULL, 1.4923, 3.9900, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Tires and Tubes', N'Road Tire Tube', N'Conventional all-purpose tube.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (923, N'Touring Tire Tube', N'TT-T092', NULL, 1.8663, 4.9900, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Tires and Tubes', N'Touring Tire Tube', N'General purpose tube.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (924, N'LL Mountain Frame - Black, 42', N'FR-M21B-42', N'Black', 136.7850, 249.7900, N'42', CAST(1324.48 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'LL Mountain Frame', N'Our best value utilizing the same, ground-breaking frame technology as the ML aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (925, N'LL Mountain Frame - Black, 44', N'FR-M21B-44', N'Black', 136.7850, 249.7900, N'44', CAST(1342.63 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'LL Mountain Frame', N'Our best value utilizing the same, ground-breaking frame technology as the ML aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (926, N'LL Mountain Frame - Black, 48', N'FR-M21B-48', N'Black', 136.7850, 249.7900, N'48', CAST(1360.77 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'LL Mountain Frame', N'Our best value utilizing the same, ground-breaking frame technology as the ML aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (927, N'LL Mountain Frame - Black, 52', N'FR-M21B-52', N'Black', 136.7850, 249.7900, N'52', CAST(1378.91 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'LL Mountain Frame', N'Our best value utilizing the same, ground-breaking frame technology as the ML aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (928, N'LL Mountain Tire', N'TI-M267', NULL, 9.3463, 24.9900, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Tires and Tubes', N'LL Mountain Tire', N'Comparible traction, less expensive wire bead casing.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (929, N'ML Mountain Tire', N'TI-M602', NULL, 11.2163, 29.9900, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Tires and Tubes', N'ML Mountain Tire', N'Great traction, high-density rubber.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (930, N'HL Mountain Tire', N'TI-M823', NULL, 13.0900, 35.0000, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Tires and Tubes', N'HL Mountain Tire', N'Incredible traction, lightweight carbon reinforced.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (931, N'LL Road Tire', N'TI-R092', NULL, 8.0373, 21.4900, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Tires and Tubes', N'LL Road Tire', N'Same great treads as more expensive tire with a less expensive wire bead casing.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (932, N'ML Road Tire', N'TI-R628', NULL, 9.3463, 24.9900, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Tires and Tubes', N'ML Road Tire', N'Higher density rubber.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (933, N'HL Road Tire', N'TI-R982', NULL, 12.1924, 32.6000, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Tires and Tubes', N'HL Road Tire', N'Lightweight carbon reinforced  for an unrivaled ride at an un-compromised weight.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (934, N'Touring Tire', N'TI-T723', NULL, 10.8423, 28.9900, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Tires and Tubes', N'Touring Tire', N'High-density rubber.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (935, N'LL Mountain Pedal', N'PD-M282', N'Silver/Black', 17.9776, 40.4900, NULL, CAST(218.00 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Pedals', N'LL Mountain Pedal', N'Expanded platform so you can ride in any shoes; great for all-around riding.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (936, N'ML Mountain Pedal', N'PD-M340', N'Silver/Black', 27.5680, 62.0900, NULL, CAST(215.00 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Pedals', N'ML Mountain Pedal', N'Lightweight, durable, clipless pedal with adjustable tension.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (937, N'HL Mountain Pedal', N'PD-M562', N'Silver/Black', 35.9596, 80.9900, NULL, CAST(185.00 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Pedals', N'HL Mountain Pedal', N'Stainless steel; designed to shed mud easily.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (938, N'LL Road Pedal', N'PD-R347', N'Silver/Black', 17.9776, 40.4900, NULL, CAST(189.00 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Pedals', N'LL Road Pedal', N'Clipless pedals - aluminum.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (939, N'ML Road Pedal', N'PD-R563', N'Silver/Black', 27.5680, 62.0900, NULL, CAST(168.00 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Pedals', N'ML Road Pedal', N'Lightweight aluminum alloy construction.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (940, N'HL Road Pedal', N'PD-R853', N'Silver/Black', 35.9596, 80.9900, NULL, CAST(149.00 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Pedals', N'HL Road Pedal', N'Top-of-the-line clipless pedals with adjustable tension.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (941, N'Touring Pedal', N'PD-T852', N'Silver/Black', 35.9596, 80.9900, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Pedals', N'Touring Pedal', N'A stable pedal for all-day riding.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (942, N'ML Mountain Frame-W - Silver, 38', N'FR-M63S-38', N'Silver', 199.3757, 364.0900, N'38', CAST(1238.30 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'ML Mountain Frame-W', N'The ML frame is a heat-treated aluminum frame made with the same detail and quality as our HL frame. It offers superior performance. Men''s version.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (943, N'LL Mountain Frame - Black, 40', N'FR-M21B-40', N'Black', 136.7850, 249.7900, N'40', CAST(1306.34 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'LL Mountain Frame', N'Our best value utilizing the same, ground-breaking frame technology as the ML aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (944, N'LL Mountain Frame - Silver, 40', N'FR-M21S-40', N'Silver', 144.5938, 264.0500, N'40', CAST(1306.34 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Frames', N'LL Mountain Frame', N'Our best value utilizing the same, ground-breaking frame technology as the ML aluminum frame.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (945, N'Front Derailleur', N'FD-2342', N'Silver', 40.6216, 91.4900, NULL, CAST(88.00 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Derailleurs', N'Front Derailleur', N'Wide-link design.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (946, N'LL Touring Handlebars', N'HB-T721', NULL, 20.4640, 46.0900, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Handlebars', N'LL Touring Handlebars', N'Unique shape reduces fatigue for entry level riders.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (947, N'HL Touring Handlebars', N'HB-T928', NULL, 40.6571, 91.5700, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Handlebars', N'HL Touring Handlebars', N'A light yet stiff aluminum bar for long distance riding.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (948, N'Front Brakes', N'FB-9873', N'Silver', 47.2860, 106.5000, NULL, CAST(317.00 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Brakes', N'Front Brakes', N'All-weather brake pads; provides superior stopping by applying more surface to the rim.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (949, N'LL Crankset', N'CS-4759', N'Black', 77.9176, 175.4900, NULL, CAST(600.00 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Cranksets', N'LL Crankset', N'Super rigid spindle.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (950, N'ML Crankset', N'CS-6583', N'Black', 113.8816, 256.4900, NULL, CAST(635.00 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Cranksets', N'ML Crankset', N'High-strength crank arm.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (951, N'HL Crankset', N'CS-9183', N'Black', 179.8156, 404.9900, NULL, CAST(575.00 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Cranksets', N'HL Crankset', N'Triple crankset; alumunim crank arm; flawless shifting.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (952, N'Chain', N'CH-0234', N'Silver', 8.9866, 20.2400, NULL, NULL, CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Chains', N'Chain', N'Superior shifting performance.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (953, N'Touring-2000 Blue, 60', N'BK-T44U-60', N'Blue', 755.1508, 1214.8500, N'60', CAST(12655.16 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-2000', N'The plush custom saddle keeps you riding all day,  and there''s plenty of space to add panniers and bike bags to the newly-redesigned carrier.  This bike has stability when fully-loaded.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (954, N'Touring-1000 Yellow, 46', N'BK-T79Y-46', N'Yellow', 1481.9379, 2384.0700, N'46', CAST(11398.72 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-1000', N'Travel in style and comfort. Designed for maximum comfort and safety. Wide gear range takes on all hills. High-tech aluminum alloy construction provides durability without added weight.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (955, N'Touring-1000 Yellow, 50', N'BK-T79Y-50', N'Yellow', 1481.9379, 2384.0700, N'50', CAST(11530.26 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-1000', N'Travel in style and comfort. Designed for maximum comfort and safety. Wide gear range takes on all hills. High-tech aluminum alloy construction provides durability without added weight.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (956, N'Touring-1000 Yellow, 54', N'BK-T79Y-54', N'Yellow', 1481.9379, 2384.0700, N'54', CAST(11648.19 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-1000', N'Travel in style and comfort. Designed for maximum comfort and safety. Wide gear range takes on all hills. High-tech aluminum alloy construction provides durability without added weight.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (957, N'Touring-1000 Yellow, 60', N'BK-T79Y-60', N'Yellow', 1481.9379, 2384.0700, N'60', CAST(11747.98 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-1000', N'Travel in style and comfort. Designed for maximum comfort and safety. Wide gear range takes on all hills. High-tech aluminum alloy construction provides durability without added weight.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (958, N'Touring-3000 Blue, 54', N'BK-T18U-54', N'Blue', 461.4448, 742.3500, N'54', CAST(13462.55 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-3000', N'All-occasion value bike with our basic comfort and safety features. Offers wider, more stable tires for a ride around town or weekend trip.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (959, N'Touring-3000 Blue, 58', N'BK-T18U-58', N'Blue', 461.4448, 742.3500, N'58', CAST(13562.34 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-3000', N'All-occasion value bike with our basic comfort and safety features. Offers wider, more stable tires for a ride around town or weekend trip.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (960, N'Touring-3000 Blue, 62', N'BK-T18U-62', N'Blue', 461.4448, 742.3500, N'62', CAST(13607.70 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-3000', N'All-occasion value bike with our basic comfort and safety features. Offers wider, more stable tires for a ride around town or weekend trip.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (961, N'Touring-3000 Yellow, 44', N'BK-T18Y-44', N'Yellow', 461.4448, 742.3500, N'44', CAST(13049.78 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-3000', N'All-occasion value bike with our basic comfort and safety features. Offers wider, more stable tires for a ride around town or weekend trip.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (962, N'Touring-3000 Yellow, 50', N'BK-T18Y-50', N'Yellow', 461.4448, 742.3500, N'50', CAST(13213.08 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-3000', N'All-occasion value bike with our basic comfort and safety features. Offers wider, more stable tires for a ride around town or weekend trip.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (963, N'Touring-3000 Yellow, 54', N'BK-T18Y-54', N'Yellow', 461.4448, 742.3500, N'54', CAST(13344.62 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-3000', N'All-occasion value bike with our basic comfort and safety features. Offers wider, more stable tires for a ride around town or weekend trip.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (964, N'Touring-3000 Yellow, 58', N'BK-T18Y-58', N'Yellow', 461.4448, 742.3500, N'58', CAST(13512.45 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-3000', N'All-occasion value bike with our basic comfort and safety features. Offers wider, more stable tires for a ride around town or weekend trip.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (965, N'Touring-3000 Yellow, 62', N'BK-T18Y-62', N'Yellow', 461.4448, 742.3500, N'62', CAST(13607.70 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-3000', N'All-occasion value bike with our basic comfort and safety features. Offers wider, more stable tires for a ride around town or weekend trip.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (966, N'Touring-1000 Blue, 46', N'BK-T79U-46', N'Blue', 1481.9379, 2384.0700, N'46', CAST(11398.72 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-1000', N'Travel in style and comfort. Designed for maximum comfort and safety. Wide gear range takes on all hills. High-tech aluminum alloy construction provides durability without added weight.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (967, N'Touring-1000 Blue, 50', N'BK-T79U-50', N'Blue', 1481.9379, 2384.0700, N'50', CAST(11530.26 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-1000', N'Travel in style and comfort. Designed for maximum comfort and safety. Wide gear range takes on all hills. High-tech aluminum alloy construction provides durability without added weight.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (968, N'Touring-1000 Blue, 54', N'BK-T79U-54', N'Blue', 1481.9379, 2384.0700, N'54', CAST(11648.19 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-1000', N'Travel in style and comfort. Designed for maximum comfort and safety. Wide gear range takes on all hills. High-tech aluminum alloy construction provides durability without added weight.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (969, N'Touring-1000 Blue, 60', N'BK-T79U-60', N'Blue', 1481.9379, 2384.0700, N'60', CAST(11747.98 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-1000', N'Travel in style and comfort. Designed for maximum comfort and safety. Wide gear range takes on all hills. High-tech aluminum alloy construction provides durability without added weight.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (970, N'Touring-2000 Blue, 46', N'BK-T44U-46', N'Blue', 755.1508, 1214.8500, N'46', CAST(12305.90 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-2000', N'The plush custom saddle keeps you riding all day,  and there''s plenty of space to add panniers and bike bags to the newly-redesigned carrier.  This bike has stability when fully-loaded.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (971, N'Touring-2000 Blue, 50', N'BK-T44U-50', N'Blue', 755.1508, 1214.8500, N'50', CAST(12437.44 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-2000', N'The plush custom saddle keeps you riding all day,  and there''s plenty of space to add panniers and bike bags to the newly-redesigned carrier.  This bike has stability when fully-loaded.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (972, N'Touring-2000 Blue, 54', N'BK-T44U-54', N'Blue', 755.1508, 1214.8500, N'54', CAST(12555.37 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-2000', N'The plush custom saddle keeps you riding all day,  and there''s plenty of space to add panniers and bike bags to the newly-redesigned carrier.  This bike has stability when fully-loaded.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (973, N'Road-350-W Yellow, 40', N'BK-R79Y-40', N'Yellow', 1082.5100, 1700.9900, N'40', CAST(6962.61 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Road Bikes', N'Road-350-W', N'Cross-train, race, or just socialize on a sleek, aerodynamic bike designed for a woman.  Advanced seat technology provides comfort all day.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (974, N'Road-350-W Yellow, 42', N'BK-R79Y-42', N'Yellow', 1082.5100, 1700.9900, N'42', CAST(7153.11 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Road Bikes', N'Road-350-W', N'Cross-train, race, or just socialize on a sleek, aerodynamic bike designed for a woman.  Advanced seat technology provides comfort all day.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (975, N'Road-350-W Yellow, 44', N'BK-R79Y-44', N'Yellow', 1082.5100, 1700.9900, N'44', CAST(7316.41 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Road Bikes', N'Road-350-W', N'Cross-train, race, or just socialize on a sleek, aerodynamic bike designed for a woman.  Advanced seat technology provides comfort all day.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (976, N'Road-350-W Yellow, 48', N'BK-R79Y-48', N'Yellow', 1082.5100, 1700.9900, N'48', CAST(7447.95 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Road Bikes', N'Road-350-W', N'Cross-train, race, or just socialize on a sleek, aerodynamic bike designed for a woman.  Advanced seat technology provides comfort all day.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (977, N'Road-750 Black, 58', N'BK-R19B-58', N'Black', 343.6496, 539.9900, N'58', CAST(9430.14 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Road Bikes', N'Road-750', N'Entry level adult bike; offers a comfortable ride cross-country or down the block. Quick-release hubs and rims.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (978, N'Touring-3000 Blue, 44', N'BK-T18U-44', N'Blue', 461.4448, 742.3500, N'44', CAST(13049.78 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-3000', N'All-occasion value bike with our basic comfort and safety features. Offers wider, more stable tires for a ride around town or weekend trip.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (979, N'Touring-3000 Blue, 50', N'BK-T18U-50', N'Blue', 461.4448, 742.3500, N'50', CAST(13213.08 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Touring Bikes', N'Touring-3000', N'All-occasion value bike with our basic comfort and safety features. Offers wider, more stable tires for a ride around town or weekend trip.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (980, N'Mountain-400-W Silver, 38', N'BK-M38S-38', N'Silver', 419.7784, 769.4900, N'38', CAST(11952.10 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-400-W', N'This bike delivers a high-level of performance on a budget. It is responsive and maneuverable, and offers peace-of-mind when you decide to go off-road.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (981, N'Mountain-400-W Silver, 40', N'BK-M38S-40', N'Silver', 419.7784, 769.4900, N'40', CAST(12142.60 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-400-W', N'This bike delivers a high-level of performance on a budget. It is responsive and maneuverable, and offers peace-of-mind when you decide to go off-road.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (982, N'Mountain-400-W Silver, 42', N'BK-M38S-42', N'Silver', 419.7784, 769.4900, N'42', CAST(12305.90 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-400-W', N'This bike delivers a high-level of performance on a budget. It is responsive and maneuverable, and offers peace-of-mind when you decide to go off-road.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (983, N'Mountain-400-W Silver, 46', N'BK-M38S-46', N'Silver', 419.7784, 769.4900, N'46', CAST(12437.44 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-400-W', N'This bike delivers a high-level of performance on a budget. It is responsive and maneuverable, and offers peace-of-mind when you decide to go off-road.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (984, N'Mountain-500 Silver, 40', N'BK-M18S-40', N'Silver', 308.2179, 564.9900, N'40', CAST(12405.69 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-500', N'Suitable for any type of riding, on or off-road. Fits any budget. Smooth-shifting with a comfortable ride.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (985, N'Mountain-500 Silver, 42', N'BK-M18S-42', N'Silver', 308.2179, 564.9900, N'42', CAST(12596.19 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-500', N'Suitable for any type of riding, on or off-road. Fits any budget. Smooth-shifting with a comfortable ride.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (986, N'Mountain-500 Silver, 44', N'BK-M18S-44', N'Silver', 308.2179, 564.9900, N'44', CAST(12759.49 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-500', N'Suitable for any type of riding, on or off-road. Fits any budget. Smooth-shifting with a comfortable ride.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (987, N'Mountain-500 Silver, 48', N'BK-M18S-48', N'Silver', 308.2179, 564.9900, N'48', CAST(12891.03 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-500', N'Suitable for any type of riding, on or off-road. Fits any budget. Smooth-shifting with a comfortable ride.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (988, N'Mountain-500 Silver, 52', N'BK-M18S-52', N'Silver', 308.2179, 564.9900, N'52', CAST(13008.96 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-500', N'Suitable for any type of riding, on or off-road. Fits any budget. Smooth-shifting with a comfortable ride.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (989, N'Mountain-500 Black, 40', N'BK-M18B-40', N'Black', 294.5797, 539.9900, N'40', CAST(12405.69 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-500', N'Suitable for any type of riding, on or off-road. Fits any budget. Smooth-shifting with a comfortable ride.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (990, N'Mountain-500 Black, 42', N'BK-M18B-42', N'Black', 294.5797, 539.9900, N'42', CAST(12596.19 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-500', N'Suitable for any type of riding, on or off-road. Fits any budget. Smooth-shifting with a comfortable ride.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (991, N'Mountain-500 Black, 44', N'BK-M18B-44', N'Black', 294.5797, 539.9900, N'44', CAST(12759.49 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-500', N'Suitable for any type of riding, on or off-road. Fits any budget. Smooth-shifting with a comfortable ride.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (992, N'Mountain-500 Black, 48', N'BK-M18B-48', N'Black', 294.5797, 539.9900, N'48', CAST(12891.03 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-500', N'Suitable for any type of riding, on or off-road. Fits any budget. Smooth-shifting with a comfortable ride.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (993, N'Mountain-500 Black, 52', N'BK-M18B-52', N'Black', 294.5797, 539.9900, N'52', CAST(13008.96 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Mountain Bikes', N'Mountain-500', N'Suitable for any type of riding, on or off-road. Fits any budget. Smooth-shifting with a comfortable ride.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (994, N'LL Bottom Bracket', N'BB-7421', NULL, 23.9716, 53.9900, NULL, CAST(223.00 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Bottom Brackets', N'LL Bottom Bracket', N'Chromoly steel.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (995, N'ML Bottom Bracket', N'BB-8107', NULL, 44.9506, 101.2400, NULL, CAST(168.00 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Bottom Brackets', N'ML Bottom Bracket', N'Aluminum alloy cups; large diameter spindle.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (996, N'HL Bottom Bracket', N'BB-9108', NULL, 53.9416, 121.4900, NULL, CAST(170.00 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Bottom Brackets', N'HL Bottom Bracket', N'Aluminum alloy cups and a hollow axle.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (997, N'Road-750 Black, 44', N'BK-R19B-44', N'Black', 343.6496, 539.9900, N'44', CAST(8967.47 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Road Bikes', N'Road-750', N'Entry level adult bike; offers a comfortable ride cross-country or down the block. Quick-release hubs and rims.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (998, N'Road-750 Black, 48', N'BK-R19B-48', N'Black', 343.6496, 539.9900, N'48', CAST(9130.77 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Road Bikes', N'Road-750', N'Entry level adult bike; offers a comfortable ride cross-country or down the block. Quick-release hubs and rims.')
INSERT [dbo].[Products] ([ProductID], [Name], [ProductNumber], [Color], [StandardCost], [ListPrice], [Size], [Weight], [SellStartDate], [SellEndDate], [DiscontinuedDate], [CategoryName], [ModelName], [Description]) VALUES (999, N'Road-750 Black, 52', N'BK-R19B-52', N'Black', 343.6496, 539.9900, N'52', CAST(9262.31 AS Decimal(8, 2)), CAST(0x000093A900000000 AS DateTime), NULL, NULL, N'Road Bikes', N'Road-750', N'Entry level adult bike; offers a comfortable ride cross-country or down the block. Quick-release hubs and rims.')


